--create schema
--connect jdbc:derby://localhost:1527/test' user 'uname' password 'pass';
create schema uname authorization uname;
set schema uname;

create table ttable (
	--id integer default autoincrement: start 1 increment 1 not null generated always as identity (start with 1, increment by 1),
	id integer not null generated always as identity (start with 1, increment by 1),
	value varchar(100),
	description varchar(100),
	created date,
	constraint ttable_pk primary key (id)
);

insert into ttable (value, description, created) values('second', 'description', '2024-03-25');
insert into ttable (value, description, created) values('third', 'description', '2024-03-25');
insert into ttable (value, description, created) values('fourth', 'description', '2024-03-25');
insert into ttable (value, description, created) values('fifth', 'description', '2024-03-25');
